<!DOCTYPE html>
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="generator" content="ApiGen 2.8.0" />
	<meta name="robots" content="noindex" />

	<title>File gestorBuscador.php | COCHESBBDD</title>

	<script type="text/javascript" src="resources/combined.js?290130469"></script>
	<script type="text/javascript" src="elementlist.js?460226330"></script>
	<link rel="stylesheet" type="text/css" media="all" href="resources/style.css?3505392360" />

</head>

<body>
<div id="left">
	<div id="menu">
		<a href="index.html" title="Overview"><span>Overview</span></a>


		<div id="groups">
		</div>



		<div id="elements">





			<h3>Functions</h3>
			<ul>
				<li><a href="function-_lb0de1b3aa06_title.html">_lb0de1b3aa06_title</a></li>
				<li><a href="function-_lb3fe2589956_elements.html">_lb3fe2589956_elements</a></li>
				<li><a href="function-_lbbc26d139f0_content.html">_lbbc26d139f0_content</a></li>
				<li><a href="function-_lbe369fc63b3_group.html">_lbe369fc63b3_group</a></li>
				<li><a href="function-_lbee30356045_elements.html">_lbee30356045_elements</a></li>
				<li><a href="function-closeConnection.html">closeConnection</a></li>
				<li><a href="function-getListaClaseEnergetica.html">getListaClaseEnergetica</a></li>
				<li><a href="function-getListadoMarcas.html">getListadoMarcas</a></li>
				<li><a href="function-getModelos.html">getModelos</a></li>
				<li class="active"><a href="function-openConnection.html">openConnection</a></li>
			</ul>
		</div>
	</div>
</div>

<div id="splitter"></div>

<div id="right">
<div id="rightInner">
	<form id="search">
		<input type="hidden" name="cx" value="" />
		<input type="hidden" name="ie" value="UTF-8" />
		<input type="text" name="q" class="text" />
		<input type="submit" value="Search" />
	</form>

	<div id="navigation">
		<ul>
			<li>
				<a href="index.html" title="Overview"><span>Overview</span></a>
			</li>
			<li>
				<a href="function-openConnection.html" title="Summary of openConnection"><span>Function</span></a>
			</li>
		</ul>
		<ul>
			<li>
				<a href="tree.html" title="Tree view of classes, interfaces, traits and exceptions"><span>Tree</span></a>
			</li>
		</ul>
		<ul>
		</ul>
	</div>

<pre><code><span id="1" class="l"><a class="l" href="#1"> 1: </a><span class="xlang">&lt;?php</span>
</span><span id="2" class="l"><a class="l" href="#2"> 2: </a><span class="php-keyword1">function</span> <a id="_openConnection" href="#_openConnection">openConnection</a>() {
</span><span id="3" class="l"><a class="l" href="#3"> 3: </a>    <span class="php-var">$db</span> = <span class="php-keyword1">new</span> mysqli(<span class="php-quote">'localhost'</span>, <span class="php-quote">'root'</span>, <span class="php-quote">''</span>, <span class="php-quote">'co01-coches'</span>);
</span><span id="4" class="l"><a class="l" href="#4"> 4: </a>    <span class="php-keyword1">if</span> (<span class="php-var">$db</span>-&gt;connect_errno &gt; <span class="php-num">0</span>) {
</span><span id="5" class="l"><a class="l" href="#5"> 5: </a>        <span class="php-keyword1">die</span>(<span class="php-quote">'Unable to connect to database ['</span> . <span class="php-var">$db</span>-&gt;connect_error . <span class="php-quote">']'</span>);
</span><span id="6" class="l"><a class="l" href="#6"> 6: </a>    }
</span><span id="7" class="l"><a class="l" href="#7"> 7: </a>    <span class="php-keyword1">return</span> <span class="php-var">$db</span>;
</span><span id="8" class="l"><a class="l" href="#8"> 8: </a>}
</span><span id="9" class="l"><a class="l" href="#9"> 9: </a><span class="php-keyword1">function</span> <a id="_closeConnection" href="#_closeConnection">closeConnection</a>(<span class="php-var">$db</span>){
</span><span id="10" class="l"><a class="l" href="#10">10: </a>    <span class="php-var">$db</span>-&gt;close();
</span><span id="11" class="l"><a class="l" href="#11">11: </a>    <span class="php-keyword1">return</span>;
</span><span id="12" class="l"><a class="l" href="#12">12: </a>}
</span><span id="13" class="l"><a class="l" href="#13">13: </a><span class="php-keyword1">function</span> <a id="_getListadoMarcas" href="#_getListadoMarcas">getListadoMarcas</a>() {
</span><span id="14" class="l"><a class="l" href="#14">14: </a>    <span class="php-var">$db</span> = openConnection();
</span><span id="15" class="l"><a class="l" href="#15">15: </a>    <span class="php-comment">//Conexion con la BBDD sin utilizar funciones componentes externas</span>
</span><span id="16" class="l"><a class="l" href="#16">16: </a>    <span class="php-comment">//$db = new mysqli('localhost', 'root', '', 'co01-coches');</span>
</span><span id="17" class="l"><a class="l" href="#17">17: </a>    <span class="php-comment">//if ($db-&gt;connect_errno &gt; 0) {</span>
</span><span id="18" class="l"><a class="l" href="#18">18: </a>    <span class="php-comment">//die('Unable to connect to database [' . $db-&gt;connect_error . ']');</span>
</span><span id="19" class="l"><a class="l" href="#19">19: </a>    <span class="php-comment">//    }</span>
</span><span id="20" class="l"><a class="l" href="#20">20: </a>    <span class="php-comment">//Sentencia Sq</span>
</span><span id="21" class="l"><a class="l" href="#21">21: </a>    <span class="php-var">$sql</span> = <span class="php-quote">&quot;SELECT ID,MARCA from co01_marcas&quot;</span>;
</span><span id="22" class="l"><a class="l" href="#22">22: </a>    <span class="php-var">$result</span> = <span class="php-var">$db</span>-&gt;query(<span class="php-var">$sql</span>);
</span><span id="23" class="l"><a class="l" href="#23">23: </a>    
</span><span id="24" class="l"><a class="l" href="#24">24: </a>    <span class="php-comment">//Desconexion con la BBDD sin utilizar funciones componentes externas   </span>
</span><span id="25" class="l"><a class="l" href="#25">25: </a>    <span class="php-comment">//$db-&gt;close();</span>
</span><span id="26" class="l"><a class="l" href="#26">26: </a>    closeConnection(<span class="php-var">$db</span>);
</span><span id="27" class="l"><a class="l" href="#27">27: </a>    <span class="php-keyword1">return</span> <span class="php-var">$result</span>;
</span><span id="28" class="l"><a class="l" href="#28">28: </a>}
</span><span id="29" class="l"><a class="l" href="#29">29: </a><span class="php-keyword1">function</span> <a id="_getListaClaseEnergetica" href="#_getListaClaseEnergetica">getListaClaseEnergetica</a>() {
</span><span id="30" class="l"><a class="l" href="#30">30: </a>    <span class="php-var">$db</span> = openConnection();
</span><span id="31" class="l"><a class="l" href="#31">31: </a><span class="php-comment">//Sentencia Sq</span>
</span><span id="32" class="l"><a class="l" href="#32">32: </a>    <span class="php-var">$sql</span> = <span class="php-quote">&quot;SELECT DISTINCT C_ENERGETICA from co01_modelos ORDER BY C_ENERGETICA ASC&quot;</span>;
</span><span id="33" class="l"><a class="l" href="#33">33: </a>    <span class="php-var">$result</span> = <span class="php-var">$db</span>-&gt;query(<span class="php-var">$sql</span>);
</span><span id="34" class="l"><a class="l" href="#34">34: </a>    
</span><span id="35" class="l"><a class="l" href="#35">35: </a>    closeConnection(<span class="php-var">$db</span>);
</span><span id="36" class="l"><a class="l" href="#36">36: </a>    <span class="php-keyword1">return</span> <span class="php-var">$result</span>;
</span><span id="37" class="l"><a class="l" href="#37">37: </a> 
</span><span id="38" class="l"><a class="l" href="#38">38: </a>}
</span><span id="39" class="l"><a class="l" href="#39">39: </a><span class="php-keyword1">function</span> <a id="_getModelos" href="#_getModelos">getModelos</a>(<span class="php-var">$marca</span>,<span class="php-var">$consumo</span>,<span class="php-var">$pagina</span>) {
</span><span id="40" class="l"><a class="l" href="#40">40: </a>    
</span><span id="41" class="l"><a class="l" href="#41">41: </a>    <span class="php-var">$startrow</span>= <span class="php-var">$pagina</span>*<span class="php-num">8</span>;
</span><span id="42" class="l"><a class="l" href="#42">42: </a>    <span class="php-var">$db</span> = openConnection();
</span><span id="43" class="l"><a class="l" href="#43">43: </a>    <span class="php-keyword1">if</span> (<span class="php-var">$marca</span>==<span class="php-num">0</span>){
</span><span id="44" class="l"><a class="l" href="#44">44: </a>        <span class="php-var">$sql</span> = <span class="php-quote">&quot;SELECT * FROM CO01_MODELOS WHERE CONSUMO&lt;=&quot;</span> . <span class="php-var">$consumo</span> . <span class="php-quote">&quot; LIMIT &quot;</span>. <span class="php-var">$startrow</span> .<span class="php-quote">&quot;,8&quot;</span>;         
</span><span id="45" class="l"><a class="l" href="#45">45: </a>    } <span class="php-keyword1">else</span> {
</span><span id="46" class="l"><a class="l" href="#46">46: </a>        <span class="php-var">$sql</span> = <span class="php-quote">&quot;SELECT * FROM CO01_MODELOS WHERE MARCA=&quot;</span> . <span class="php-var">$marca</span> . <span class="php-quote">&quot; AND CONSUMO&lt;=&quot;</span> . <span class="php-var">$consumo</span> . <span class="php-quote">&quot; LIMIT &quot;</span> . <span class="php-var">$startrow</span>.<span class="php-quote">&quot;,8&quot;</span>; 
</span><span id="47" class="l"><a class="l" href="#47">47: </a>    }
</span><span id="48" class="l"><a class="l" href="#48">48: </a>    <span class="php-keyword2">error_log</span> (<span class="php-quote">&quot;********&quot;</span> . <span class="php-var">$sql</span>);
</span><span id="49" class="l"><a class="l" href="#49">49: </a>    <span class="php-var">$result</span> = <span class="php-var">$db</span>-&gt;query(<span class="php-var">$sql</span>);
</span><span id="50" class="l"><a class="l" href="#50">50: </a>    closeConnection(<span class="php-var">$db</span>);
</span><span id="51" class="l"><a class="l" href="#51">51: </a>    <span class="php-keyword1">return</span> <span class="php-var">$result</span>;
</span><span id="52" class="l"><a class="l" href="#52">52: </a>}
</span><span id="53" class="l"><a class="l" href="#53">53: </a></span><span class="xlang">?&gt;</span></code></pre>

	<div id="footer">
		COCHESBBDD API documentation generated by <a href="http://apigen.org">ApiGen 2.8.0</a>
	</div>
</div>
</div>
</body>
</html>
